insert overwrite table yl_ods.tab_barscan_signrep partition(dt)
select
recordid
,billcode
,delivertime
,receipttype
,deliveruser
,null as signuser
,signedstatus
,inputuser
,inputtime
,remark
,inputsite
,deliverfee
,freightcollect
,sendstation
,null as destination
,realweight
,cod
,fctomonth
,fccurrency
,deliverfeecurrency
,codcurrency
,codflag
,sendsite
,destsite
,senddate
,recepitsigned
,siteaccountflag
,fcmonthlyaccount
,transferflag
,transfertime
,transferuser
,commision
,inputtype
,modifystatus
,currency
,collecttype
,shifts
,commisionremark
,pcs
,chargedweight
,contractarea
,agentflag
,scansitecode
,uploadtime
,remark3
,scanusercode
,send_deliver_usercode
,nextstationcode
,source
,remark5
,remark6
,remark4
,scansiteid
,nextstationid
,scanuserid
,send_deliver_userid
,dt
from jms_ods.tab_barscan_signrep
where dt = '{{ execution_date | cst_ds }}' ;
